Overview

Brought to you by YData

Dataset statistics

Number of variables	29
Number of observations	160609
Missing cells	1202395
Missing cells (%)	25.8%
Duplicate rows	1003
Duplicate rows (%)	0.6%
Total size in memory	165.8 MiB
Average record size in memory	1.1 KiB

Variable types

DateTime	4
Categorical	12
Numeric	9
Text	4

Alerts

`year` has constant value "2024"	Constant
`Cancelled Rides by Customer` has constant value "1.0"	Constant
`Cancelled Rides by Driver` has constant value "1.0"	Constant
`Incomplete Rides` has constant value "1.0"	Constant
Dataset has 1003 (0.6%) duplicate rows	Duplicates
`Booking Status` is highly overall correlated with `Customer Rating` and 4 other fields	High correlation
`Customer Rating` is highly overall correlated with `Booking Status`	High correlation
`Driver Cancellation Reason` is highly overall correlated with `Booking Status`	High correlation
`Driver Ratings` is highly overall correlated with `Booking Status`	High correlation
`Incomplete Rides Reason` is highly overall correlated with `Booking Status`	High correlation
`Reason for cancelling by Customer` is highly overall correlated with `Booking Status`	High correlation
`Ride Distance` has 51280 (31.9%) missing values	Missing
`Booking Value` has 51280 (31.9%) missing values	Missing
`Avg VTAT` has 11207 (7.0%) missing values	Missing
`Avg CTAT` has 51280 (31.9%) missing values	Missing
`Cancelled Rides by Customer` has 149355 (93.0%) missing values	Missing
`Reason for cancelling by Customer` has 149355 (93.0%) missing values	Missing
`Cancelled Rides by Driver` has 131790 (82.1%) missing values	Missing
`Driver Cancellation Reason` has 131790 (82.1%) missing values	Missing
`Incomplete Rides` has 150946 (94.0%) missing values	Missing
`Incomplete Rides Reason` has 150946 (94.0%) missing values	Missing
`Driver Ratings` has 60943 (37.9%) missing values	Missing
`Customer Rating` has 60943 (37.9%) missing values	Missing
`Payment Method` has 51280 (31.9%) missing values	Missing

Reproduction

Analysis started	2026-01-29 05:50:44.531106
Analysis finished	2026-01-29 05:51:35.135569
Duration	50.6 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

datetime
Date

Distinct	149532
Distinct (%)	93.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Minimum	2024-01-01 00:19:34
Maximum	2024-12-30 23:36:11
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Date
Date

Distinct	365
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Minimum	2024-01-01 00:00:00
Maximum	2024-12-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Time
Date

Distinct	62910
Distinct (%)	39.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Minimum	2026-01-29 00:00:00
Maximum	2026-01-29 23:59:59
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

year
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.3 MiB

2024	160609

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	642436
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2024
2nd row	2024
3rd row	2024
4th row	2024
5th row	2024

Common Values

Value	Count	Frequency (%)
2024	160609	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2024	160609	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	321218	50.0%
0	160609	25.0%
4	160609	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	642436	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	321218	50.0%
0	160609	25.0%
4	160609	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	642436	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	321218	50.0%
0	160609	25.0%
4	160609	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	642436	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	321218	50.0%
0	160609	25.0%
4	160609	25.0%

month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.548232

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.3693271
Coefficient of variation (CV)	0.51453996
Kurtosis	-1.1423814
Mean	6.548232
Median Absolute Deviation (MAD)	3
Skewness	-0.040028967
Sum	1051705
Variance	11.352365
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	19323	12.0%
10	14861	9.3%
8	13102	8.2%
4	13092	8.2%
1	12933	8.1%
5	12844	8.0%
3	12791	8.0%
6	12540	7.8%
11	12450	7.8%
12	12332	7.7%
Other values (2)	24341	15.2%

Value	Count	Frequency (%)
1	12933	8.1%
2	12017	7.5%
3	12791	8.0%
4	13092	8.2%
5	12844	8.0%
6	12540	7.8%
7	19323	12.0%
8	13102	8.2%
9	12324	7.7%
10	14861	9.3%

Value	Count	Frequency (%)
12	12332	7.7%
11	12450	7.8%
10	14861	9.3%
9	12324	7.7%
8	13102	8.2%
7	19323	12.0%
6	12540	7.8%
5	12844	8.0%
4	13092	8.2%
3	12791	8.0%

day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.175955

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7790546
Coefficient of variation (CV)	0.57848448
Kurtosis	-1.1882037
Mean	15.175955
Median Absolute Deviation (MAD)	8
Skewness	0.090717827
Sum	2437395
Variance	77.071799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
5	5922	3.7%
4	5908	3.7%
3	5870	3.7%
12	5842	3.6%
2	5770	3.6%
10	5754	3.6%
11	5736	3.6%
15	5725	3.6%
6	5500	3.4%
1	5491	3.4%
Other values (21)	103091	64.2%

Value	Count	Frequency (%)
1	5491	3.4%
2	5770	3.6%
3	5870	3.7%
4	5908	3.7%
5	5922	3.7%
6	5500	3.4%
7	5343	3.3%
8	5382	3.4%
9	5481	3.4%
10	5754	3.6%

Value	Count	Frequency (%)
31	2405	1.5%
30	4466	2.8%
29	4890	3.0%
28	4864	3.0%
27	4901	3.1%
26	5035	3.1%
25	4927	3.1%
24	4981	3.1%
23	4866	3.0%
22	5012	3.1%

weekday
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.8 MiB

Saturday	23413
Thursday	23411
Wednesday	23264
Monday	23026
Friday	22780
Other values (2)	44715

Length

Max length	9
Median length	8
Mean length	7.1568218
Min length	6

Characters and Unicode

Total characters	1149450
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Saturday
2nd row	Friday
3rd row	Friday
4th row	Monday
5th row	Monday

Common Values

Value	Count	Frequency (%)
Saturday	23413	14.6%
Thursday	23411	14.6%
Wednesday	23264	14.5%
Monday	23026	14.3%
Friday	22780	14.2%
Sunday	22359	13.9%
Tuesday	22356	13.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
saturday	23413	14.6%
thursday	23411	14.6%
wednesday	23264	14.5%
monday	23026	14.3%
friday	22780	14.2%
sunday	22359	13.9%
tuesday	22356	13.9%

Most occurring characters

Value	Count	Frequency (%)
a	184022	16.0%
d	183873	16.0%
y	160609	14.0%
u	91539	8.0%
r	69604	6.1%
s	69031	6.0%
e	68884	6.0%
n	68649	6.0%
S	45772	4.0%
T	45767	4.0%
Other values (7)	161700	14.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	988841	86.0%
Uppercase Letter	160609	14.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	184022	18.6%
d	183873	18.6%
y	160609	16.2%
u	91539	9.3%
r	69604	7.0%
s	69031	7.0%
e	68884	7.0%
n	68649	6.9%
t	23413	2.4%
h	23411	2.4%
Other values (2)	45806	4.6%

Uppercase Letter

Value	Count	Frequency (%)
S	45772	28.5%
T	45767	28.5%
W	23264	14.5%
M	23026	14.3%
F	22780	14.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1149450	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	184022	16.0%
d	183873	16.0%
y	160609	14.0%
u	91539	8.0%
r	69604	6.1%
s	69031	6.0%
e	68884	6.0%
n	68649	6.0%
S	45772	4.0%
T	45767	4.0%
Other values (7)	161700	14.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1149450	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	184022	16.0%
d	183873	16.0%
y	160609	14.0%
u	91539	8.0%
r	69604	6.1%
s	69031	6.0%
e	68884	6.0%
n	68649	6.0%
S	45772	4.0%
T	45767	4.0%
Other values (7)	161700	14.1%

hour
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.032302

Minimum	0
Maximum	23
Zeros	1469
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	10
median	15
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.4145955
Coefficient of variation (CV)	0.38586652
Kurtosis	-0.65176385
Mean	14.032302
Median Absolute Deviation (MAD)	4
Skewness	-0.41504767
Sum	2253714
Variance	29.317845
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
18	13321	8.3%
17	11859	7.4%
19	11828	7.4%
20	10313	6.4%
10	10292	6.4%
16	10281	6.4%
11	8996	5.6%
9	8828	5.5%
15	8769	5.5%
21	8651	5.4%
Other values (14)	57471	35.8%

Value	Count	Frequency (%)
0	1469	0.9%
1	1456	0.9%
2	1430	0.9%
3	1472	0.9%
4	1412	0.9%
5	2960	1.8%
6	4486	2.8%
7	5817	3.6%
8	7357	4.6%
9	8828	5.5%

Value	Count	Frequency (%)
23	2954	1.8%
22	5793	3.6%
21	8651	5.4%
20	10313	6.4%
19	11828	7.4%
18	13321	8.3%
17	11859	7.4%
16	10281	6.4%
15	8769	5.5%
14	7523	4.7%

ride_date
Date

Distinct	365
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Minimum	2024-01-01 00:00:00
Maximum	2024-12-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Event
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

Normal Day	73084
Wedding_Season	33173
Monsoon	31838
Navratri	6673
Monsoon_Sales	6318
Other values (11)	9523

Length

Max length	16
Median length	14
Mean length	10.255036
Min length	4

Characters and Unicode

Total characters	1647051
Distinct characters	38
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Normal Day
2nd row	Wedding_Season
3rd row	Monsoon
4th row	Normal Day
5th row	Normal Day

Common Values

Value	Count	Frequency (%)
Normal Day	73084	45.5%
Wedding_Season	33173	20.7%
Monsoon	31838	19.8%
Navratri	6673	4.2%
Monsoon_Sales	6318	3.9%
Diwali	2466	1.5%
Festive_Sales	2058	1.3%
Eid-ul-Adha	834	0.5%
Eid-ul-Fitr	833	0.5%
Christmas	796	0.5%
Other values (6)	2536	1.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
day	73940	31.4%
normal	73084	31.0%
wedding_season	33173	14.1%
monsoon	31838	13.5%
navratri	6673	2.8%
monsoon_sales	6318	2.7%
diwali	2466	1.0%
festive_sales	2058	0.9%
eid-ul-adha	834	0.4%
eid-ul-fitr	833	0.4%
Other values (9)	4173	1.8%

Most occurring characters

Value	Count	Frequency (%)
o	221106	13.4%
a	208164	12.6%
n	144720	8.8%
r	88933	5.4%
l	86426	5.2%
s	84271	5.1%
e	82196	5.0%
N	80173	4.9%
D	76864	4.7%
	74781	4.5%
Other values (28)	499417	30.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1248781	75.8%
Uppercase Letter	278606	16.9%
Space Separator	74781	4.5%
Connector Punctuation	41549	2.5%
Dash Punctuation	3334	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	221106	17.7%
a	208164	16.7%
n	144720	11.6%
r	88933	7.1%
l	86426	6.9%
s	84271	6.7%
e	82196	6.6%
y	74365	6.0%
m	73880	5.9%
d	70080	5.6%
Other values (10)	114640	9.2%

Uppercase Letter

Value	Count	Frequency (%)
N	80173	28.8%
D	76864	27.6%
S	41549	14.9%
M	38156	13.7%
W	33173	11.9%
F	2891	1.0%
E	1667	0.6%
A	834	0.3%
C	796	0.3%
R	452	0.2%
Other values (5)	2051	0.7%

Space Separator

Value	Count	Frequency (%)
	74781	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	41549	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3334	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1527387	92.7%
Common	119664	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	221106	14.5%
a	208164	13.6%
n	144720	9.5%
r	88933	5.8%
l	86426	5.7%
s	84271	5.5%
e	82196	5.4%
N	80173	5.2%
D	76864	5.0%
y	74365	4.9%
Other values (25)	380169	24.9%

Common

Value	Count	Frequency (%)
	74781	62.5%
_	41549	34.7%
-	3334	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1647051	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	221106	13.4%
a	208164	12.6%
n	144720	8.8%
r	88933	5.4%
l	86426	5.2%
s	84271	5.1%
e	82196	5.0%
N	80173	4.9%
D	76864	4.7%
	74781	4.5%
Other values (28)	499417	30.3%

Booking ID
Text

Distinct	148767
Distinct (%)	92.6%
Missing	0
Missing (%)	0.0%
Memory size	10.6 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	1927308
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	137241 ?
Unique (%)	85.5%

Sample

1st row	"CNR5884300"
2nd row	"CNR1326809"
3rd row	"CNR8494506"
4th row	"CNR8906825"
5th row	"CNR1950162"

Value	Count	Frequency (%)
cnr8281555	4	< 0.1%
cnr2918341	4	< 0.1%
cnr2624320	4	< 0.1%
cnr2080548	4	< 0.1%
cnr4767660	4	< 0.1%
cnr1015148	4	< 0.1%
cnr9295320	4	< 0.1%
cnr8928908	4	< 0.1%
cnr2740651	4	< 0.1%
cnr5229368	4	< 0.1%
Other values (148757)	160569	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
"	321218	16.7%
C	160609	8.3%
N	160609	8.3%
R	160609	8.3%
9	114665	5.9%
7	114387	5.9%
4	114378	5.9%
6	114321	5.9%
5	114258	5.9%
2	114190	5.9%
Other values (4)	438064	22.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1124263	58.3%
Uppercase Letter	481827	25.0%
Other Punctuation	321218	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	114665	10.2%
7	114387	10.2%
4	114378	10.2%
6	114321	10.2%
5	114258	10.2%
2	114190	10.2%
1	114164	10.2%
8	114048	10.1%
3	113798	10.1%
0	96054	8.5%

Uppercase Letter

Value	Count	Frequency (%)
C	160609	33.3%
N	160609	33.3%
R	160609	33.3%

Other Punctuation

Value	Count	Frequency (%)
"	321218	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1445481	75.0%
Latin	481827	25.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
"	321218	22.2%
9	114665	7.9%
7	114387	7.9%
4	114378	7.9%
6	114321	7.9%
5	114258	7.9%
2	114190	7.9%
1	114164	7.9%
8	114048	7.9%
3	113798	7.9%

Latin

Value	Count	Frequency (%)
C	160609	33.3%
N	160609	33.3%
R	160609	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1927308	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
"	321218	16.7%
C	160609	8.3%
N	160609	8.3%
R	160609	8.3%
9	114665	5.9%
7	114387	5.9%
4	114378	5.9%
6	114321	5.9%
5	114258	5.9%
2	114190	5.9%
Other values (4)	438064	22.7%

Booking Status
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.6 MiB

Completed	99666
Cancelled by Driver	28819
Cancelled by Customer	11254
No Driver Found	11207
Incomplete	9663

Length

Max length	21
Median length	9
Mean length	12.114041
Min length	9

Characters and Unicode

Total characters	1945624
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Driver Found
2nd row	Incomplete
3rd row	Completed
4th row	Completed
5th row	Completed

Common Values

Value	Count	Frequency (%)
Completed	99666	62.1%
Cancelled by Driver	28819	17.9%
Cancelled by Customer	11254	7.0%
No Driver Found	11207	7.0%
Incomplete	9663	6.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
completed	99666	37.9%
cancelled	40073	15.2%
by	40073	15.2%
driver	40026	15.2%
customer	11254	4.3%
no	11207	4.3%
found	11207	4.3%
incomplete	9663	3.7%

Most occurring characters

Value	Count	Frequency (%)
e	350084	18.0%
l	189475	9.7%
C	150993	7.8%
d	150946	7.8%
o	142997	7.3%
m	120583	6.2%
t	120583	6.2%
p	109329	5.6%
	102560	5.3%
r	91306	4.7%
Other values (13)	416768	21.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1619968	83.3%
Uppercase Letter	223096	11.5%
Space Separator	102560	5.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	350084	21.6%
l	189475	11.7%
d	150946	9.3%
o	142997	8.8%
m	120583	7.4%
t	120583	7.4%
p	109329	6.7%
r	91306	5.6%
n	60943	3.8%
c	49736	3.1%
Other values (7)	233986	14.4%

Uppercase Letter

Value	Count	Frequency (%)
C	150993	67.7%
D	40026	17.9%
N	11207	5.0%
F	11207	5.0%
I	9663	4.3%

Space Separator

Value	Count	Frequency (%)
	102560	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1843064	94.7%
Common	102560	5.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	350084	19.0%
l	189475	10.3%
C	150993	8.2%
d	150946	8.2%
o	142997	7.8%
m	120583	6.5%
t	120583	6.5%
p	109329	5.9%
r	91306	5.0%
n	60943	3.3%
Other values (12)	355825	19.3%

Common

Value	Count	Frequency (%)
	102560	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1945624	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	350084	18.0%
l	189475	9.7%
C	150993	7.8%
d	150946	7.8%
o	142997	7.3%
m	120583	6.2%
t	120583	6.2%
p	109329	5.6%
	102560	5.3%
r	91306	4.7%
Other values (13)	416768	21.4%

Customer ID
Text

Distinct	148788
Distinct (%)	92.6%
Missing	0
Missing (%)	0.0%
Memory size	10.6 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	1927308
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	137264 ?
Unique (%)	85.5%

Sample

1st row	"CID1982111"
2nd row	"CID4604802"
3rd row	"CID9202816"
4th row	"CID2610914"
5th row	"CID9933542"

Value	Count	Frequency (%)
cid8418985	4	< 0.1%
cid9681675	4	< 0.1%
cid1044355	4	< 0.1%
cid4833362	4	< 0.1%
cid5102441	4	< 0.1%
cid8253544	4	< 0.1%
cid4701042	4	< 0.1%
cid8165460	4	< 0.1%
cid7303248	4	< 0.1%
cid9629712	4	< 0.1%
Other values (148778)	160569	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
"	321218	16.7%
C	160609	8.3%
I	160609	8.3%
D	160609	8.3%
4	114765	6.0%
6	114587	5.9%
1	114561	5.9%
9	114307	5.9%
5	114020	5.9%
7	114013	5.9%
Other values (4)	438010	22.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1124263	58.3%
Uppercase Letter	481827	25.0%
Other Punctuation	321218	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	114765	10.2%
6	114587	10.2%
1	114561	10.2%
9	114307	10.2%
5	114020	10.1%
7	114013	10.1%
3	113997	10.1%
8	113986	10.1%
2	113589	10.1%
0	96438	8.6%

Uppercase Letter

Value	Count	Frequency (%)
C	160609	33.3%
I	160609	33.3%
D	160609	33.3%

Other Punctuation

Value	Count	Frequency (%)
"	321218	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1445481	75.0%
Latin	481827	25.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
"	321218	22.2%
4	114765	7.9%
6	114587	7.9%
1	114561	7.9%
9	114307	7.9%
5	114020	7.9%
7	114013	7.9%
3	113997	7.9%
8	113986	7.9%
2	113589	7.9%

Latin

Value	Count	Frequency (%)
C	160609	33.3%
I	160609	33.3%
D	160609	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1927308	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
"	321218	16.7%
C	160609	8.3%
I	160609	8.3%
D	160609	8.3%
4	114765	6.0%
6	114587	5.9%
1	114561	5.9%
9	114307	5.9%
5	114020	5.9%
7	114013	5.9%
Other values (4)	438010	22.7%

Vehicle Type
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

Auto	40066
Go Mini	31873
Go Sedan	29042
Bike	24108
Premier Sedan	19453
Other values (2)	16067

Length

Max length	13
Median length	8
Mean length	6.5683181
Min length	4

Characters and Unicode

Total characters	1054931
Distinct characters	22
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	eBike
2nd row	Go Sedan
3rd row	Auto
4th row	Premier Sedan
5th row	Bike

Common Values

Value	Count	Frequency (%)
Auto	40066	24.9%
Go Mini	31873	19.8%
Go Sedan	29042	18.1%
Bike	24108	15.0%
Premier Sedan	19453	12.1%
eBike	11285	7.0%
Uber XL	4782	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
go	60915	24.8%
sedan	48495	19.7%
auto	40066	16.3%
mini	31873	13.0%
bike	24108	9.8%
premier	19453	7.9%
ebike	11285	4.6%
uber	4782	1.9%
xl	4782	1.9%

Most occurring characters

Value	Count	Frequency (%)
e	138861	13.2%
i	118592	11.2%
o	100981	9.6%
	85150	8.1%
n	80368	7.6%
G	60915	5.8%
d	48495	4.6%
a	48495	4.6%
S	48495	4.6%
r	43688	4.1%
Other values (12)	280891	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	719240	68.2%
Uppercase Letter	250541	23.7%
Space Separator	85150	8.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	138861	19.3%
i	118592	16.5%
o	100981	14.0%
n	80368	11.2%
d	48495	6.7%
a	48495	6.7%
r	43688	6.1%
u	40066	5.6%
t	40066	5.6%
k	35393	4.9%
Other values (2)	24235	3.4%

Uppercase Letter

Value	Count	Frequency (%)
G	60915	24.3%
S	48495	19.4%
A	40066	16.0%
B	35393	14.1%
M	31873	12.7%
P	19453	7.8%
U	4782	1.9%
X	4782	1.9%
L	4782	1.9%

Space Separator

Value	Count	Frequency (%)
	85150	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	969781	91.9%
Common	85150	8.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	138861	14.3%
i	118592	12.2%
o	100981	10.4%
n	80368	8.3%
G	60915	6.3%
d	48495	5.0%
a	48495	5.0%
S	48495	5.0%
r	43688	4.5%
u	40066	4.1%
Other values (11)	240825	24.8%

Common

Value	Count	Frequency (%)
	85150	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1054931	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	138861	13.2%
i	118592	11.2%
o	100981	9.6%
	85150	8.1%
n	80368	7.6%
G	60915	5.8%
d	48495	4.6%
a	48495	4.6%
S	48495	4.6%
r	43688	4.1%
Other values (12)	280891	26.6%

Pickup Location
Text

Distinct	176
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.5 MiB

Length

Max length	25
Median length	19
Mean length	11.504978
Min length	3

Characters and Unicode

Total characters	1847803
Distinct characters	58
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Palam Vihar
2nd row	Shastri Nagar
3rd row	Khandsa
4th row	Central Secretariat
5th row	Ghitorni Village

Value	Count	Frequency (%)
nagar	15520	5.2%
vihar	9032	3.0%
chowk	7376	2.5%
park	5593	1.9%
gurgaon	5374	1.8%
sector	5354	1.8%
road	4546	1.5%
noida	4507	1.5%
city	3734	1.3%
garden	3655	1.2%
Other values (214)	233229	78.3%

Most occurring characters

Value	Count	Frequency (%)
a	297186	16.1%
r	137624	7.4%
	137311	7.4%
i	117500	6.4%
h	95650	5.2%
n	80066	4.3%
e	77209	4.2%
o	73657	4.0%
t	60143	3.3%
u	57330	3.1%
Other values (48)	714127	38.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1374375	74.4%
Uppercase Letter	323617	17.5%
Space Separator	137311	7.4%
Decimal Number	12500	0.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	297186	21.6%
r	137624	10.0%
i	117500	8.5%
h	95650	7.0%
n	80066	5.8%
e	77209	5.6%
o	73657	5.4%
t	60143	4.4%
u	57330	4.2%
d	55757	4.1%
Other values (15)	322253	23.4%

Uppercase Letter

Value	Count	Frequency (%)
S	32801	10.1%
N	28251	8.7%
P	25659	7.9%
M	25637	7.9%
G	25292	7.8%
C	23798	7.4%
K	18420	5.7%
B	17417	5.4%
R	17327	5.4%
I	15594	4.8%
Other values (14)	93421	28.9%

Decimal Number

Value	Count	Frequency (%)
2	2722	21.8%
1	2699	21.6%
5	1790	14.3%
6	1785	14.3%
3	900	7.2%
4	892	7.1%
9	870	7.0%
8	842	6.7%

Space Separator

Value	Count	Frequency (%)
	137311	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1697992	91.9%
Common	149811	8.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	297186	17.5%
r	137624	8.1%
i	117500	6.9%
h	95650	5.6%
n	80066	4.7%
e	77209	4.5%
o	73657	4.3%
t	60143	3.5%
u	57330	3.4%
d	55757	3.3%
Other values (39)	645870	38.0%

Common

Value	Count	Frequency (%)
	137311	91.7%
2	2722	1.8%
1	2699	1.8%
5	1790	1.2%
6	1785	1.2%
3	900	0.6%
4	892	0.6%
9	870	0.6%
8	842	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1847803	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	297186	16.1%
r	137624	7.4%
	137311	7.4%
i	117500	6.4%
h	95650	5.2%
n	80066	4.3%
e	77209	4.2%
o	73657	4.0%
t	60143	3.3%
u	57330	3.1%
Other values (48)	714127	38.6%

Drop Location
Text

Distinct	176
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.5 MiB

Length

Max length	25
Median length	20
Mean length	11.513022
Min length	3

Characters and Unicode

Total characters	1849095
Distinct characters	58
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jhilmil
2nd row	Gurgaon Sector 56
3rd row	Malviya Nagar
4th row	Inderlok
5th row	Khan Market

Value	Count	Frequency (%)
nagar	15590	5.2%
vihar	9153	3.1%
chowk	7152	2.4%
sector	5495	1.8%
gurgaon	5474	1.8%
park	5377	1.8%
noida	4616	1.5%
road	4420	1.5%
gate	3729	1.2%
delhi	3720	1.2%
Other values (214)	233661	78.3%

Most occurring characters

Value	Count	Frequency (%)
a	296655	16.0%
	137778	7.5%
r	137702	7.4%
i	117601	6.4%
h	96066	5.2%
n	80097	4.3%
e	77672	4.2%
o	74016	4.0%
t	60267	3.3%
u	57151	3.1%
Other values (48)	714090	38.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1374931	74.4%
Uppercase Letter	323513	17.5%
Space Separator	137778	7.5%
Decimal Number	12873	0.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	296655	21.6%
r	137702	10.0%
i	117601	8.6%
h	96066	7.0%
n	80097	5.8%
e	77672	5.6%
o	74016	5.4%
t	60267	4.4%
u	57151	4.2%
d	55343	4.0%
Other values (15)	322361	23.4%

Uppercase Letter

Value	Count	Frequency (%)
S	32779	10.1%
N	28630	8.8%
P	25583	7.9%
M	25563	7.9%
G	25538	7.9%
C	23306	7.2%
K	18424	5.7%
B	17183	5.3%
R	17166	5.3%
V	15457	4.8%
Other values (14)	93884	29.0%

Decimal Number

Value	Count	Frequency (%)
1	2742	21.3%
2	2696	20.9%
5	1883	14.6%
6	1865	14.5%
3	942	7.3%
4	941	7.3%
8	916	7.1%
9	888	6.9%

Space Separator

Value	Count	Frequency (%)
	137778	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1698444	91.9%
Common	150651	8.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	296655	17.5%
r	137702	8.1%
i	117601	6.9%
h	96066	5.7%
n	80097	4.7%
e	77672	4.6%
o	74016	4.4%
t	60267	3.5%
u	57151	3.4%
d	55343	3.3%
Other values (39)	645874	38.0%

Common

Value	Count	Frequency (%)
	137778	91.5%
1	2742	1.8%
2	2696	1.8%
5	1883	1.2%
6	1865	1.2%
3	942	0.6%
4	941	0.6%
8	916	0.6%
9	888	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1849095	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	296655	16.0%
	137778	7.5%
r	137702	7.4%
i	117601	6.4%
h	96066	5.2%
n	80097	4.3%
e	77672	4.2%
o	74016	4.0%
t	60267	3.3%
u	57151	3.1%
Other values (48)	714090	38.6%

Ride Distance
Real number (ℝ)

Missing

Distinct	4901
Distinct (%)	4.5%
Missing	51280
Missing (%)	31.9%
Infinite	0
Infinite (%)	0.0%
Mean	24.616326

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	3.97
Q1	12.43
median	23.67
Q3	36.79
95-th percentile	47.35
Maximum	50
Range	49
Interquartile range (IQR)	24.36

Descriptive statistics

Standard deviation	13.999738
Coefficient of variation (CV)	0.56871762
Kurtosis	-1.2118066
Mean	24.616326
Median Absolute Deviation (MAD)	12.09
Skewness	0.13028125
Sum	2691278.3
Variance	195.99268
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.61	47	< 0.1%
14.93	46	< 0.1%
3.44	45	< 0.1%
17.31	44	< 0.1%
14.47	44	< 0.1%
12.52	43	< 0.1%
12.87	43	< 0.1%
15.02	42	< 0.1%
8.69	41	< 0.1%
8.97	41	< 0.1%
Other values (4891)	108893	67.8%
(Missing)	51280	31.9%

Value	Count	Frequency (%)
1	6	< 0.1%
1.01	3	< 0.1%
1.02	5	< 0.1%
1.03	5	< 0.1%
1.04	3	< 0.1%
1.05	3	< 0.1%
1.06	5	< 0.1%
1.07	8	< 0.1%
1.08	1	< 0.1%
1.09	6	< 0.1%

Value	Count	Frequency (%)
50	10	< 0.1%
49.99	20	< 0.1%
49.98	22	< 0.1%
49.97	22	< 0.1%
49.96	21	< 0.1%
49.95	17	< 0.1%
49.94	21	< 0.1%
49.93	25	< 0.1%
49.92	17	< 0.1%
49.91	19	< 0.1%

Booking Value
Real number (ℝ)

Missing

Distinct	2566
Distinct (%)	2.3%
Missing	51280
Missing (%)	31.9%
Infinite	0
Infinite (%)	0.0%
Mean	508.63849

Minimum	50
Maximum	4277
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	50
5-th percentile	91
Q1	234
median	414
Q3	689
95-th percentile	1225
Maximum	4277
Range	4227
Interquartile range (IQR)	455

Descriptive statistics

Standard deviation	396.31267
Coefficient of variation (CV)	0.77916373
Kurtosis	9.9549601
Mean	508.63849
Median Absolute Deviation (MAD)	211
Skewness	2.2955538
Sum	55608938
Variance	157063.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	186	0.1%
176	185	0.1%
125	182	0.1%
157	181	0.1%
470	181	0.1%
249	180	0.1%
408	180	0.1%
240	180	0.1%
98	179	0.1%
186	178	0.1%
Other values (2556)	107517	66.9%
(Missing)	51280	31.9%

Value	Count	Frequency (%)
50	132	0.1%
51	113	0.1%
52	123	0.1%
53	146	0.1%
54	103	0.1%
55	111	0.1%
56	122	0.1%
57	120	0.1%
58	118	0.1%
59	125	0.1%

Value	Count	Frequency (%)
4277	2	< 0.1%
4228	1	< 0.1%
4220	1	< 0.1%
4202	1	< 0.1%
4133	2	< 0.1%
4109	1	< 0.1%
4093	1	< 0.1%
4088	1	< 0.1%
4060	1	< 0.1%
4044	1	< 0.1%

Avg VTAT
Real number (ℝ)

Missing

Distinct	181
Distinct (%)	0.1%
Missing	11207
Missing (%)	7.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.4521171

Minimum	2
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	2
5-th percentile	2.9
Q1	5.3
median	8.3
Q3	11.3
95-th percentile	14.6
Maximum	20
Range	18
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.7720348
Coefficient of variation (CV)	0.44628283
Kurtosis	-0.5949816
Mean	8.4521171
Median Absolute Deviation (MAD)	3
Skewness	0.30841726
Sum	1262763.2
Variance	14.228246
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.4	1352	0.8%
5.8	1348	0.8%
6.5	1347	0.8%
6	1340	0.8%
9.5	1339	0.8%
6.2	1335	0.8%
7.4	1323	0.8%
7.7	1320	0.8%
8.9	1319	0.8%
5.1	1315	0.8%
Other values (171)	136064	84.7%
(Missing)	11207	7.0%

Value	Count	Frequency (%)
2	436	0.3%
2.1	902	0.6%
2.2	830	0.5%
2.3	843	0.5%
2.4	869	0.5%
2.5	888	0.6%
2.6	878	0.5%
2.7	834	0.5%
2.8	873	0.5%
2.9	884	0.6%

Value	Count	Frequency (%)
20	39	< 0.1%
19.9	93	0.1%
19.8	83	0.1%
19.7	73	< 0.1%
19.6	79	< 0.1%
19.5	61	< 0.1%
19.4	97	0.1%
19.3	64	< 0.1%
19.2	84	0.1%
19.1	65	< 0.1%

Avg CTAT
Real number (ℝ)

Missing

Distinct	351
Distinct (%)	0.3%
Missing	51280
Missing (%)	31.9%
Infinite	0
Infinite (%)	0.0%
Mean	29.137421

Minimum	10
Maximum	45
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	10
5-th percentile	15.8
Q1	21.6
median	28.7
Q3	36.8
95-th percentile	43.3
Maximum	45
Range	35
Interquartile range (IQR)	15.2

Descriptive statistics

Standard deviation	8.9071902
Coefficient of variation (CV)	0.3056959
Kurtosis	-1.1256407
Mean	29.137421
Median Absolute Deviation (MAD)	7.6
Skewness	0.047091738
Sum	3185565.1
Variance	79.338037
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.8	426	0.3%
18.5	423	0.3%
20	419	0.3%
23.5	419	0.3%
28.1	417	0.3%
21.1	412	0.3%
25.9	410	0.3%
20.5	409	0.3%
22.4	409	0.3%
26.6	408	0.3%
Other values (341)	105177	65.5%
(Missing)	51280	31.9%

Value	Count	Frequency (%)
10	24	< 0.1%
10.1	53	< 0.1%
10.2	49	< 0.1%
10.3	45	< 0.1%
10.4	54	< 0.1%
10.5	49	< 0.1%
10.6	50	< 0.1%
10.7	50	< 0.1%
10.8	50	< 0.1%
10.9	44	< 0.1%

Value	Count	Frequency (%)
45	149	0.1%
44.9	336	0.2%
44.8	333	0.2%
44.7	352	0.2%
44.6	332	0.2%
44.5	318	0.2%
44.4	340	0.2%
44.3	282	0.2%
44.2	320	0.2%
44.1	335	0.2%

Cancelled Rides by Customer
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	149355
Missing (%)	93.0%
Memory size	9.8 MiB

1.0	11254

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	33762
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	11254	7.0%
(Missing)	149355	93.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	11254	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	11254	33.3%
.	11254	33.3%
0	11254	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	22508	66.7%
Other Punctuation	11254	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	11254	50.0%
0	11254	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	11254	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	33762	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	11254	33.3%
.	11254	33.3%
0	11254	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33762	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	11254	33.3%
.	11254	33.3%
0	11254	33.3%

Reason for cancelling by Customer
Categorical

High correlation Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	149355
Missing (%)	93.0%
Memory size	10.0 MiB

Change of plans	2531
Wrong Address	2515
Driver is not moving towards pickup location	2512
Driver asked to cancel	2452
AC is not working	1244

Length

Max length	44
Median length	17
Mean length	22.772348
Min length	13

Characters and Unicode

Total characters	256280
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Driver is not moving towards pickup location
2nd row	Driver is not moving towards pickup location
3rd row	Driver asked to cancel
4th row	Driver is not moving towards pickup location
5th row	Driver asked to cancel

Common Values

Value	Count	Frequency (%)
Change of plans	2531	1.6%
Wrong Address	2515	1.6%
Driver is not moving towards pickup location	2512	1.6%
Driver asked to cancel	2452	1.5%
AC is not working	1244	0.8%
(Missing)	149355	93.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
driver	4964	11.0%
is	3756	8.3%
not	3756	8.3%
change	2531	5.6%
plans	2531	5.6%
of	2531	5.6%
wrong	2515	5.6%
address	2515	5.6%
pickup	2512	5.6%
location	2512	5.6%
Other values (7)	14868	33.0%

Most occurring characters

Value	Count	Frequency (%)
	33737	13.2%
o	22546	8.8%
n	20053	7.8%
r	18714	7.3%
i	17500	6.8%
s	16281	6.4%
a	14990	5.8%
e	14914	5.8%
t	11232	4.4%
d	9994	3.9%
Other values (15)	76319	29.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	207530	81.0%
Space Separator	33737	13.2%
Uppercase Letter	15013	5.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	22546	10.9%
n	20053	9.7%
r	18714	9.0%
i	17500	8.4%
s	16281	7.8%
a	14990	7.2%
e	14914	7.2%
t	11232	5.4%
d	9994	4.8%
c	9928	4.8%
Other values (10)	51378	24.8%

Uppercase Letter

Value	Count	Frequency (%)
D	4964	33.1%
C	3775	25.1%
A	3759	25.0%
W	2515	16.8%

Space Separator

Value	Count	Frequency (%)
	33737	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	222543	86.8%
Common	33737	13.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	22546	10.1%
n	20053	9.0%
r	18714	8.4%
i	17500	7.9%
s	16281	7.3%
a	14990	6.7%
e	14914	6.7%
t	11232	5.0%
d	9994	4.5%
c	9928	4.5%
Other values (14)	66391	29.8%

Common

Value	Count	Frequency (%)
	33737	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	256280	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	33737	13.2%
o	22546	8.8%
n	20053	7.8%
r	18714	7.3%
i	17500	6.8%
s	16281	6.4%
a	14990	5.8%
e	14914	5.8%
t	11232	4.4%
d	9994	3.9%
Other values (15)	76319	29.8%

Cancelled Rides by Driver
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	131790
Missing (%)	82.1%
Memory size	9.7 MiB

1.0	28819

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	86457
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	28819	17.9%
(Missing)	131790	82.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	28819	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	28819	33.3%
.	28819	33.3%
0	28819	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	57638	66.7%
Other Punctuation	28819	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	28819	50.0%
0	28819	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	28819	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	86457	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	28819	33.3%
.	28819	33.3%
0	28819	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86457	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	28819	33.3%
.	28819	33.3%
0	28819	33.3%

Driver Cancellation Reason
Categorical

High correlation Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	131790
Missing (%)	82.1%
Memory size	10.4 MiB

Customer related issue	7282
The customer was coughing/sick	7211
Personal & Car related issues	7176
More than permitted people in there	7150

Length

Max length	35
Median length	30
Mean length	28.970054
Min length	22

Characters and Unicode

Total characters	834888
Distinct characters	25
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Personal & Car related issues
2nd row	Customer related issue
3rd row	Customer related issue
4th row	Personal & Car related issues
5th row	More than permitted people in there

Common Values

Value	Count	Frequency (%)
Customer related issue	7282	4.5%
The customer was coughing/sick	7211	4.5%
Personal & Car related issues	7176	4.5%
More than permitted people in there	7150	4.5%
(Missing)	131790	82.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
customer	14493	11.2%
related	14458	11.2%
issue	7282	5.6%
the	7211	5.6%
was	7211	5.6%
coughing/sick	7211	5.6%
personal	7176	5.5%
	7176	5.5%
car	7176	5.5%
issues	7176	5.5%
Other values (6)	42900	33.1%

Most occurring characters

Value	Count	Frequency (%)
e	122304	14.6%
	100651	12.1%
s	72183	8.6%
r	64753	7.8%
t	57551	6.9%
i	43180	5.2%
o	43180	5.2%
a	43171	5.2%
u	36162	4.3%
l	28784	3.4%
Other values (15)	222969	26.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	683855	81.9%
Space Separator	100651	12.1%
Uppercase Letter	35995	4.3%
Other Punctuation	14387	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	122304	17.9%
s	72183	10.6%
r	64753	9.5%
t	57551	8.4%
i	43180	6.3%
o	43180	6.3%
a	43171	6.3%
u	36162	5.3%
l	28784	4.2%
h	28722	4.2%
Other values (8)	143865	21.0%

Uppercase Letter

Value	Count	Frequency (%)
C	14458	40.2%
T	7211	20.0%
P	7176	19.9%
M	7150	19.9%

Other Punctuation

Value	Count	Frequency (%)
/	7211	50.1%
&	7176	49.9%

Space Separator

Value	Count	Frequency (%)
	100651	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	719850	86.2%
Common	115038	13.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	122304	17.0%
s	72183	10.0%
r	64753	9.0%
t	57551	8.0%
i	43180	6.0%
o	43180	6.0%
a	43171	6.0%
u	36162	5.0%
l	28784	4.0%
h	28722	4.0%
Other values (12)	179860	25.0%

Common

Value	Count	Frequency (%)
	100651	87.5%
/	7211	6.3%
&	7176	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	834888	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	122304	14.6%
	100651	12.1%
s	72183	8.6%
r	64753	7.8%
t	57551	6.9%
i	43180	5.2%
o	43180	5.2%
a	43171	5.2%
u	36162	4.3%
l	28784	3.4%
Other values (15)	222969	26.7%

Incomplete Rides
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	150946
Missing (%)	94.0%
Memory size	9.8 MiB

1.0	9663

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	28989
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	9663	6.0%
(Missing)	150946	94.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	9663	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	9663	33.3%
.	9663	33.3%
0	9663	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	19326	66.7%
Other Punctuation	9663	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	9663	50.0%
0	9663	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	9663	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	28989	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	9663	33.3%
.	9663	33.3%
0	9663	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28989	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	9663	33.3%
.	9663	33.3%
0	9663	33.3%

Incomplete Rides Reason
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	150946
Missing (%)	94.0%
Memory size	9.9 MiB

Customer Demand	3268
Vehicle Breakdown	3236
Other Issue	3159

Length

Max length	17
Median length	15
Mean length	14.362103
Min length	11

Characters and Unicode

Total characters	138781
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Vehicle Breakdown
2nd row	Other Issue
3rd row	Vehicle Breakdown
4th row	Other Issue
5th row	Vehicle Breakdown

Common Values

Value	Count	Frequency (%)
Customer Demand	3268	2.0%
Vehicle Breakdown	3236	2.0%
Other Issue	3159	2.0%
(Missing)	150946	94.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
customer	3268	16.9%
demand	3268	16.9%
vehicle	3236	16.7%
breakdown	3236	16.7%
other	3159	16.3%
issue	3159	16.3%

Most occurring characters

Value	Count	Frequency (%)
e	22562	16.3%
r	9663	7.0%
	9663	7.0%
s	9586	6.9%
m	6536	4.7%
n	6504	4.7%
d	6504	4.7%
o	6504	4.7%
a	6504	4.7%
t	6427	4.6%
Other values (13)	48328	34.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	109792	79.1%
Uppercase Letter	19326	13.9%
Space Separator	9663	7.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	22562	20.5%
r	9663	8.8%
s	9586	8.7%
m	6536	6.0%
n	6504	5.9%
d	6504	5.9%
o	6504	5.9%
a	6504	5.9%
t	6427	5.9%
u	6427	5.9%
Other values (6)	22575	20.6%

Uppercase Letter

Value	Count	Frequency (%)
C	3268	16.9%
D	3268	16.9%
V	3236	16.7%
B	3236	16.7%
O	3159	16.3%
I	3159	16.3%

Space Separator

Value	Count	Frequency (%)
	9663	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	129118	93.0%
Common	9663	7.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	22562	17.5%
r	9663	7.5%
s	9586	7.4%
m	6536	5.1%
n	6504	5.0%
d	6504	5.0%
o	6504	5.0%
a	6504	5.0%
t	6427	5.0%
u	6427	5.0%
Other values (12)	41901	32.5%

Common

Value	Count	Frequency (%)
	9663	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	138781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	22562	16.3%
r	9663	7.0%
	9663	7.0%
s	9586	6.9%
m	6536	4.7%
n	6504	4.7%
d	6504	4.7%
o	6504	4.7%
a	6504	4.7%
t	6427	4.6%
Other values (13)	48328	34.8%

Driver Ratings
Real number (ℝ)

High correlation Missing

Distinct	21
Distinct (%)	< 0.1%
Missing	60943
Missing (%)	37.9%
Infinite	0
Infinite (%)	0.0%
Mean	4.2306825

Minimum	3
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	3
5-th percentile	3.3
Q1	4.1
median	4.3
Q3	4.6
95-th percentile	4.9
Maximum	5
Range	2
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.43697093
Coefficient of variation (CV)	0.10328616
Kurtosis	0.2766847
Mean	4.2306825
Median Absolute Deviation (MAD)	0.2
Skewness	-0.6553693
Sum	421655.2
Variance	0.19094359
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
4.3	15096	9.4%
4.2	14845	9.2%
4.6	10009	6.2%
4.4	7511	4.7%
4.1	7453	4.6%
4.7	5032	3.1%
4.9	5024	3.1%
4.5	4989	3.1%
3.9	4210	2.6%
3.8	4123	2.6%
Other values (11)	21374	13.3%
(Missing)	60943	37.9%

Value	Count	Frequency (%)
3	798	0.5%
3.1	1558	1.0%
3.2	1652	1.0%
3.3	1573	1.0%
3.4	1612	1.0%
3.5	804	0.5%
3.6	2185	1.4%
3.7	4055	2.5%
3.8	4123	2.6%
3.9	4210	2.6%

Value	Count	Frequency (%)
5	2532	1.6%
4.9	5024	3.1%
4.8	2495	1.6%
4.7	5032	3.1%
4.6	10009	6.2%
4.5	4989	3.1%
4.4	7511	4.7%
4.3	15096	9.4%
4.2	14845	9.2%
4.1	7453	4.6%

Customer Rating
Real number (ℝ)

High correlation Missing

Distinct	21
Distinct (%)	< 0.1%
Missing	60943
Missing (%)	37.9%
Infinite	0
Infinite (%)	0.0%
Mean	4.404499

Minimum	3
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	3
5-th percentile	3.6
Q1	4.2
median	4.5
Q3	4.8
95-th percentile	5
Maximum	5
Range	2
Interquartile range (IQR)	0.6

Descriptive statistics

Standard deviation	0.43777579
Coefficient of variation (CV)	0.099392869
Kurtosis	0.64585631
Mean	4.404499
Median Absolute Deviation (MAD)	0.3
Skewness	-0.88417172
Sum	438978.8
Variance	0.19164765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
4.9	12463	7.8%
4.6	12395	7.7%
4.3	11812	7.4%
4.2	11468	7.1%
4.8	6306	3.9%
4.5	6278	3.9%
5	6267	3.9%
4.7	6149	3.8%
4.1	5802	3.6%
4.4	5628	3.5%
Other values (11)	15098	9.4%
(Missing)	60943	37.9%

Value	Count	Frequency (%)
3	500	0.3%
3.1	1083	0.7%
3.2	938	0.6%
3.3	961	0.6%
3.4	1003	0.6%
3.5	474	0.3%
3.6	1263	0.8%
3.7	2533	1.6%
3.8	2541	1.6%
3.9	2527	1.6%

Value	Count	Frequency (%)
5	6267	3.9%
4.9	12463	7.8%
4.8	6306	3.9%
4.7	6149	3.8%
4.6	12395	7.7%
4.5	6278	3.9%
4.4	5628	3.5%
4.3	11812	7.4%
4.2	11468	7.1%
4.1	5802	3.6%

Payment Method
Categorical

Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	51280
Missing (%)	31.9%
Memory size	9.7 MiB

UPI	49223
Cash	27176
Uber Wallet	13151
Credit Card	10959
Debit Card	8820

Length

Max length	11
Median length	10
Mean length	5.5775046
Min length	3

Characters and Unicode

Total characters	609783
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UPI
2nd row	Debit Card
3rd row	UPI
4th row	UPI
5th row	UPI

Common Values

Value	Count	Frequency (%)
UPI	49223	30.6%
Cash	27176	16.9%
Uber Wallet	13151	8.2%
Credit Card	10959	6.8%
Debit Card	8820	5.5%
(Missing)	51280	31.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
upi	49223	34.6%
cash	27176	19.1%
card	19779	13.9%
uber	13151	9.2%
wallet	13151	9.2%
credit	10959	7.7%
debit	8820	6.2%

Most occurring characters

Value	Count	Frequency (%)
U	62374	10.2%
a	60106	9.9%
C	57914	9.5%
P	49223	8.1%
I	49223	8.1%
e	46081	7.6%
r	43889	7.2%
	32930	5.4%
t	32930	5.4%
d	30738	5.0%
Other values (7)	144375	23.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	336148	55.1%
Uppercase Letter	240705	39.5%
Space Separator	32930	5.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	60106	17.9%
e	46081	13.7%
r	43889	13.1%
t	32930	9.8%
d	30738	9.1%
h	27176	8.1%
s	27176	8.1%
l	26302	7.8%
b	21971	6.5%
i	19779	5.9%

Uppercase Letter

Value	Count	Frequency (%)
U	62374	25.9%
C	57914	24.1%
P	49223	20.4%
I	49223	20.4%
W	13151	5.5%
D	8820	3.7%

Space Separator

Value	Count	Frequency (%)
	32930	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	576853	94.6%
Common	32930	5.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	62374	10.8%
a	60106	10.4%
C	57914	10.0%
P	49223	8.5%
I	49223	8.5%
e	46081	8.0%
r	43889	7.6%
t	32930	5.7%
d	30738	5.3%
h	27176	4.7%
Other values (6)	117199	20.3%

Common

Value	Count	Frequency (%)
	32930	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	609783	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	62374	10.2%
a	60106	9.9%
C	57914	9.5%
P	49223	8.1%
I	49223	8.1%
e	46081	7.6%
r	43889	7.2%
	32930	5.4%
t	32930	5.4%
d	30738	5.0%
Other values (7)	144375	23.7%

Interactions

Correlations

	Avg CTAT	Avg VTAT	Booking Status	Booking Value	Customer Rating	Driver Cancellation Reason	Driver Ratings	Event	Incomplete Rides Reason	Payment Method	Reason for cancelling by Customer	Ride Distance	Vehicle Type	day	hour	month	weekday
Avg CTAT	1.000	0.058	0.471	0.000	0.001	0.000	0.001	0.004	0.000	0.000	0.000	0.101	0.001	0.000	-0.001	-0.001	0.005
Avg VTAT	0.058	1.000	0.338	0.005	-0.003	0.000	-0.005	0.004	0.000	0.000	0.014	0.063	0.000	0.004	-0.005	0.003	0.003
Booking Status	0.471	0.338	1.000	0.006	1.000	1.000	1.000	0.000	1.000	0.000	1.000	0.353	0.003	0.000	0.000	0.001	0.004
Booking Value	0.000	0.005	0.006	1.000	-0.004	0.000	0.001	0.017	0.000	0.000	0.000	0.004	0.000	0.008	0.001	0.000	0.108
Customer Rating	0.001	-0.003	1.000	-0.004	1.000	0.000	-0.002	0.006	0.000	0.005	0.000	0.003	0.005	-0.001	-0.003	-0.000	0.000
Driver Cancellation Reason	0.000	0.000	1.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.010	0.009	0.009	0.007
Driver Ratings	0.001	-0.005	1.000	0.001	-0.002	0.000	1.000	0.000	0.000	0.000	0.000	-0.002	0.000	-0.000	0.001	-0.001	0.006
Event	0.004	0.004	0.000	0.017	0.006	0.000	0.000	1.000	0.018	0.000	0.015	0.004	0.000	0.233	0.000	0.477	0.156
Incomplete Rides Reason	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.018	1.000	0.000	0.000	0.010	0.016	0.020	0.006	0.000	0.014
Payment Method	0.000	0.000	0.000	0.000	0.005	0.000	0.000	0.000	0.000	1.000	0.000	0.005	0.006	0.006	0.003	0.006	0.004
Reason for cancelling by Customer	0.000	0.014	1.000	0.000	0.000	0.000	0.000	0.015	0.000	0.000	1.000	0.000	0.168	0.000	0.000	0.012	0.000
Ride Distance	0.101	0.063	0.353	0.004	0.003	0.000	-0.002	0.004	0.010	0.005	0.000	1.000	0.000	0.006	-0.002	0.005	0.000
Vehicle Type	0.001	0.000	0.003	0.000	0.005	0.000	0.000	0.000	0.016	0.006	0.168	0.000	1.000	0.003	0.004	0.003	0.003
day	0.000	0.004	0.000	0.008	-0.001	0.010	-0.000	0.233	0.020	0.006	0.000	0.006	0.003	1.000	-0.003	-0.019	0.069
hour	-0.001	-0.005	0.000	0.001	-0.003	0.009	0.001	0.000	0.006	0.003	0.000	-0.002	0.004	-0.003	1.000	0.000	0.000
month	-0.001	0.003	0.001	0.000	-0.000	0.009	-0.001	0.477	0.000	0.006	0.012	0.005	0.003	-0.019	0.000	1.000	0.044
weekday	0.005	0.003	0.004	0.108	0.000	0.007	0.006	0.156	0.014	0.004	0.000	0.000	0.003	0.069	0.000	0.044	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	datetime	Date	Time	year	month	day	weekday	hour	ride_date	Event	Booking ID	Booking Status	Customer ID	Vehicle Type	Pickup Location	Drop Location	Ride Distance	Booking Value	Avg VTAT	Avg CTAT	Cancelled Rides by Customer	Reason for cancelling by Customer	Cancelled Rides by Driver	Driver Cancellation Reason	Incomplete Rides	Incomplete Rides Reason	Driver Ratings	Customer Rating	Payment Method
0	2024-03-23 12:29:38	2024-03-23	12:29:38	2024	3	23	Saturday	12	2024-03-23	Normal Day	"CNR5884300"	No Driver Found	"CID1982111"	eBike	Palam Vihar	Jhilmil	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	2024-11-29 18:01:39	2024-11-29	18:01:39	2024	11	29	Friday	18	2024-11-29	Wedding_Season	"CNR1326809"	Incomplete	"CID4604802"	Go Sedan	Shastri Nagar	Gurgaon Sector 56	5.73	237.0	4.9	14.0	NaN	NaN	NaN	NaN	1.0	Vehicle Breakdown	NaN	NaN	UPI
2	2024-08-23 08:56:10	2024-08-23	08:56:10	2024	8	23	Friday	8	2024-08-23	Monsoon	"CNR8494506"	Completed	"CID9202816"	Auto	Khandsa	Malviya Nagar	13.58	627.0	13.4	25.8	NaN	NaN	NaN	NaN	NaN	NaN	4.9	4.9	Debit Card
3	2024-10-21 17:17:25	2024-10-21	17:17:25	2024	10	21	Monday	17	2024-10-21	Normal Day	"CNR8906825"	Completed	"CID2610914"	Premier Sedan	Central Secretariat	Inderlok	34.02	416.0	13.1	28.5	NaN	NaN	NaN	NaN	NaN	NaN	4.6	5.0	UPI
4	2024-09-16 22:08:00	2024-09-16	22:08:00	2024	9	16	Monday	22	2024-09-16	Normal Day	"CNR1950162"	Completed	"CID9933542"	Bike	Ghitorni Village	Khan Market	48.21	737.0	5.3	19.6	NaN	NaN	NaN	NaN	NaN	NaN	4.1	4.3	UPI
5	2024-02-06 09:44:56	2024-02-06	09:44:56	2024	2	6	Tuesday	9	2024-02-06	Wedding_Season	"CNR4096693"	Completed	"CID4670564"	Auto	AIIMS	Narsinghpur	4.85	316.0	5.1	18.1	NaN	NaN	NaN	NaN	NaN	NaN	4.1	4.6	UPI
6	2024-06-17 15:45:58	2024-06-17	15:45:58	2024	6	17	Monday	15	2024-06-17	Eid-ul-Adha	"CNR2002539"	Completed	"CID6800553"	Go Mini	Vaishali	Punjabi Bagh	41.24	640.0	7.1	20.4	NaN	NaN	NaN	NaN	NaN	NaN	4.0	4.1	UPI
7	2024-03-19 17:37:37	2024-03-19	17:37:37	2024	3	19	Tuesday	17	2024-03-19	Normal Day	"CNR6568000"	Completed	"CID8610436"	Auto	Mayur Vihar	Cyber Hub	6.56	136.0	12.1	16.5	NaN	NaN	NaN	NaN	NaN	NaN	4.4	4.2	UPI
8	2024-09-14 12:49:09	2024-09-14	12:49:09	2024	9	14	Saturday	12	2024-09-14	Monsoon	"CNR4510807"	No Driver Found	"CID7873618"	Go Sedan	Noida Sector 62	Noida Sector 18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	2024-12-16 19:06:48	2024-12-16	19:06:48	2024	12	16	Monday	19	2024-12-16	Normal Day	"CNR7721892"	Incomplete	"CID5214275"	Auto	Rohini	Adarsh Nagar	10.36	135.0	6.1	26.0	NaN	NaN	NaN	NaN	1.0	Other Issue	NaN	NaN	Cash

	datetime	Date	Time	year	month	day	weekday	hour	ride_date	Event	Booking ID	Booking Status	Customer ID	Vehicle Type	Pickup Location	Drop Location	Ride Distance	Booking Value	Avg VTAT	Avg CTAT	Cancelled Rides by Customer	Reason for cancelling by Customer	Cancelled Rides by Driver	Driver Cancellation Reason	Incomplete Rides	Incomplete Rides Reason	Driver Ratings	Customer Rating	Payment Method
160599	2024-07-13 14:47:30	2024-07-13	14:47:30	2024	7	13	Saturday	14	2024-07-13	Monsoon	"CNR5591053"	Completed	"CID1829616"	Auto	Karol Bagh	Vishwavidyalaya	27.91	597.0	11.2	30.8	NaN	NaN	NaN	NaN	NaN	NaN	4.2	4.3	UPI
160600	2024-01-24 18:02:28	2024-01-24	18:02:28	2024	1	24	Wednesday	18	2024-01-24	Normal Day	"CNR1717894"	No Driver Found	"CID9564749"	Go Mini	Nehru Place	Aya Nagar	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
160601	2024-05-03 11:18:17	2024-05-03	11:18:17	2024	5	3	Friday	11	2024-05-03	Normal Day	"CNR9715958"	Completed	"CID8835432"	Go Mini	Tughlakabad	Jama Masjid	29.89	280.0	13.2	20.1	NaN	NaN	NaN	NaN	NaN	NaN	4.1	4.7	Cash
160602	2024-06-14 16:46:53	2024-06-14	16:46:53	2024	6	14	Friday	16	2024-06-14	Normal Day	"CNR9572383"	Completed	"CID2952237"	Go Mini	Akshardham	Greater Noida	10.51	388.0	8.2	30.6	NaN	NaN	NaN	NaN	NaN	NaN	4.3	4.9	UPI
160603	2024-11-11 19:34:01	2024-11-11	19:34:01	2024	11	11	Monday	19	2024-11-11	Wedding_Season	"CNR6500631"	Completed	"CID4337371"	Go Mini	MG Road	Ghitorni	40.08	475.0	10.2	44.4	NaN	NaN	NaN	NaN	NaN	NaN	3.7	4.1	Uber Wallet
160604	2024-11-24 15:55:09	2024-11-24	15:55:09	2024	11	24	Sunday	15	2024-11-24	Wedding_Season	"CNR2468611"	Completed	"CID2325623"	Go Mini	Golf Course Road	Akshardham	21.31	1093.0	5.1	30.8	NaN	NaN	NaN	NaN	NaN	NaN	4.8	5.0	UPI
160605	2024-09-18 10:55:15	2024-09-18	10:55:15	2024	9	18	Wednesday	10	2024-09-18	Normal Day	"CNR6358306"	Completed	"CID9925486"	Go Sedan	Satguru Ram Singh Marg	Jor Bagh	15.93	852.0	2.7	23.4	NaN	NaN	NaN	NaN	NaN	NaN	3.9	4.4	Cash
160606	2024-10-05 07:53:34	2024-10-05	07:53:34	2024	10	5	Saturday	7	2024-10-05	Navratri	"CNR3030099"	Completed	"CID9415487"	Auto	Ghaziabad	Saidulajab	45.54	333.0	6.9	39.6	NaN	NaN	NaN	NaN	NaN	NaN	4.1	3.7	UPI
160607	2024-10-05 07:53:34	2024-10-05	07:53:34	2024	10	5	Saturday	7	2024-10-05	Festive_Sales	"CNR3030099"	Completed	"CID9415487"	Auto	Ghaziabad	Saidulajab	45.54	333.0	6.9	39.6	NaN	NaN	NaN	NaN	NaN	NaN	4.1	3.7	UPI
160608	2024-03-10 15:38:03	2024-03-10	15:38:03	2024	3	10	Sunday	15	2024-03-10	Wedding_Season	"CNR3447390"	Completed	"CID4108667"	Premier Sedan	Ashok Park Main	Gurgaon Sector 29	21.19	806.0	3.5	33.7	NaN	NaN	NaN	NaN	NaN	NaN	4.6	4.9	Credit Card

Duplicate rows

Most frequently occurring

	datetime	Date	Time	year	month	day	weekday	hour	ride_date	Event	Booking ID	Booking Status	Customer ID	Vehicle Type	Pickup Location	Drop Location	Ride Distance	Booking Value	Avg VTAT	Avg CTAT	Cancelled Rides by Customer	Reason for cancelling by Customer	Cancelled Rides by Driver	Driver Cancellation Reason	Incomplete Rides	Incomplete Rides Reason	Driver Ratings	Customer Rating	Payment Method	# duplicates
30	2024-01-13 09:16:53	2024-01-13	09:16:53	2024	1	13	Saturday	9	2024-01-13	Normal Day	"CNR1665871"	Cancelled by Customer	"CID4830996"	Bike	Lal Quila	Vasant Kunj	NaN	NaN	15.3	NaN	1.0	Change of plans	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3
31	2024-01-13 09:16:53	2024-01-13	09:16:53	2024	1	13	Saturday	9	2024-01-13	Normal Day	"CNR3467484"	Cancelled by Customer	"CID1585469"	Uber XL	Sadar Bazar Gurgaon	Adarsh Nagar	NaN	NaN	18.7	NaN	1.0	Change of plans	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3
32	2024-01-13 09:16:53	2024-01-13	09:16:53	2024	1	13	Saturday	9	2024-01-13	Normal Day	"CNR5995469"	Completed	"CID1368457"	eBike	Malviya Nagar	Hero Honda Chowk	7.66	445.0	5.8	22.4	NaN	NaN	NaN	NaN	NaN	NaN	4.6	4.7	Credit Card	3
0	2024-01-01 21:54:16	2024-01-01	21:54:16	2024	1	1	Monday	21	2024-01-01	New Year	"CNR9901275"	Completed	"CID9869633"	Go Sedan	Vatika Chowk	Inderlok	4.61	202.0	2.3	40.1	NaN	NaN	NaN	NaN	NaN	NaN	4.7	4.2	Cash	2
1	2024-01-01 21:54:16	2024-01-01	21:54:16	2024	1	1	Monday	21	2024-01-01	New Year	"CNR9918929"	Completed	"CID7591176"	Premier Sedan	Palam Vihar	Shastri Park	14.89	349.0	7.1	30.7	NaN	NaN	NaN	NaN	NaN	NaN	4.1	4.0	UPI	2
2	2024-01-02 17:16:29	2024-01-02	17:16:29	2024	1	2	Tuesday	17	2024-01-02	Normal Day	"CNR5455862"	Cancelled by Driver	"CID3909649"	Go Sedan	Akshardham	Malviya Nagar	NaN	NaN	7.6	NaN	NaN	NaN	1.0	Personal & Car related issues	NaN	NaN	NaN	NaN	NaN	2
3	2024-01-02 17:16:29	2024-01-02	17:16:29	2024	1	2	Tuesday	17	2024-01-02	Normal Day	"CNR9650422"	Completed	"CID4731274"	Go Mini	Old Gurgaon	Moti Nagar	34.06	1917.0	10.1	19.0	NaN	NaN	NaN	NaN	NaN	NaN	4.6	4.9	UPI	2
4	2024-01-02 17:57:47	2024-01-02	17:57:47	2024	1	2	Tuesday	17	2024-01-02	Normal Day	"CNR8346445"	Completed	"CID9173008"	Bike	Pitampura	Vishwavidyalaya	46.67	160.0	2.1	17.6	NaN	NaN	NaN	NaN	NaN	NaN	4.2	4.2	UPI	2
5	2024-01-02 17:57:47	2024-01-02	17:57:47	2024	1	2	Tuesday	17	2024-01-02	Normal Day	"CNR8949149"	Completed	"CID8694169"	Go Sedan	Barakhamba Road	Dwarka Mor	42.66	919.0	10.2	26.3	NaN	NaN	NaN	NaN	NaN	NaN	4.2	4.1	UPI	2
6	2024-01-03 09:36:43	2024-01-03	09:36:43	2024	1	3	Wednesday	9	2024-01-03	Normal Day	"CNR5832024"	Cancelled by Driver	"CID8105586"	Auto	ITO	INA Market	NaN	NaN	7.2	NaN	NaN	NaN	1.0	More than permitted people in there	NaN	NaN	NaN	NaN	NaN	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Connector Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter